Skip Headers

Oracle® Database Reference 10g Release 2 (10.2) Part Number B14237-02 |
Home | Book List | Contents | Index | Master Index | Feedback

Previous | Next
| View PDF

# V$LOGMNR_PROCESS

`V$LOGMNR_PROCESS` identifies all processes attached to an active LogMiner persistent session. (A persistent LogMiner session is created either by starting Data Guard SQL Apply on a logical standby database for the first time or by creating Streams capture.) This view can be joined with either the `V$SESSION` view or the `V$PROCESS` view to gather process-specific information.

Column | Datatype | Description
--- | --- | ---
`SESSION_ID` | `NUMBER` | Unique identifier for the LogMiner persistent session
`PID` | `NUMBER` | Oracle process identifier for the SQL Apply or Streams capture process (same as the `V$PROCESS.PID`)
`SPID` | `VARCHAR2(12)` | Operating system process identifier (same as the `V$PROCESS.SPID`)
`ROLE` | `VARCHAR2(32)` | Identifies the role of the active LogMiner process: `READER`, `PREPARER`, `BUILDER`, `COORDINATOR`, or `APPLY SERVER`
`USERNAME` | `VARCHAR2(15)` | Operating system process user name that is connected to the database
`SID` | `NUMBER` | Session identifier for the `V$SESSION.SID` process
`SERIAL#` | `NUMBER` | Session serial number associated with the `V$SESSION.SERIAL` process
`LATCHWAIT` | `VARCHAR2(8)` | Address of the latch the process is waiting for; `NULL` if none
`LATCHSPIN` | `VARCHAR2(8)` | Address of the latch the process is spinning on; `NULL` if none
`WORK_MICROSEC` | `VARCHAR2(21)` | Microseconds spent by the process doing useful work
`OVERHEAD_MICROSEC` | `VARCHAR2(21)` | Microseconds spent by the process doing overhead tasks or simply waiting/idling